﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GeebaDS" targetNamespace="http://tempuri.org/GeebaDS.xsd" xmlns:mstns="http://tempuri.org/GeebaDS.xsd" xmlns="http://tempuri.org/GeebaDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GeebaDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GeebaDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WcfGeebaServer.Properties.Settings.GlobalReference.Default.GeebaDBConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="GeebaDBConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="GeebaDBConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WcfGeebaServer.Properties.Settings.GlobalReference.Default.GeebaDBConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoggedMembersTableAdapter" GeneratorDataComponentClassName="LoggedMembersTableAdapter" Name="LoggedMembers" UserDataComponentName="LoggedMembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.LoggedMembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[LoggedMembers] WHERE (([loginId] = @Original_loginId) AND ([username] = @Original_username) AND ([loginDate] = @Original_loginDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loginId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loginId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_loginDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="loginDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[LoggedMembers] ([username], [loginDate]) VALUES (@username, @loginDate);
SELECT loginId, username, loginDate FROM LoggedMembers WHERE (loginId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@loginDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="loginDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT loginId, username, loginDate FROM dbo.LoggedMembers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[LoggedMembers] SET [username] = @username, [loginDate] = @loginDate WHERE (([loginId] = @Original_loginId) AND ([username] = @Original_username) AND ([loginDate] = @Original_loginDate));
SELECT loginId, username, loginDate FROM LoggedMembers WHERE (loginId = @loginId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@loginDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="loginDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loginId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loginId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_loginDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="loginDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="loginId" ColumnName="loginId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@loginId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="loginId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="loginId" DataSetColumn="loginId" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="loginDate" DataSetColumn="loginDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoggingTableAdapter" GeneratorDataComponentClassName="LoggingTableAdapter" Name="Logging" UserDataComponentName="LoggingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Logging" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Logging] WHERE (([logId] = @Original_logId) AND ([logDate] = @Original_logDate) AND ([logInfo] = @Original_logInfo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_logId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="logId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_logDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="logDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_logInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="logInfo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Logging] ([logDate], [logInfo]) VALUES (@logDate, @logInfo);
SELECT logId, logDate, logInfo FROM Logging WHERE (logId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@logDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="logDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@logInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="logInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT logId, logDate, logInfo FROM dbo.Logging</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Logging] SET [logDate] = @logDate, [logInfo] = @logInfo WHERE (([logId] = @Original_logId) AND ([logDate] = @Original_logDate) AND ([logInfo] = @Original_logInfo));
SELECT logId, logDate, logInfo FROM Logging WHERE (logId = @logId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@logDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="logDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@logInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="logInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_logId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="logId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_logDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="logDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_logInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="logInfo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="logId" ColumnName="logId" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\GEEBASERVER\GEEBADB.MDF].dbo.Logging" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@logId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="logId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="logId" DataSetColumn="logId" />
              <Mapping SourceColumn="logDate" DataSetColumn="logDate" />
              <Mapping SourceColumn="logInfo" DataSetColumn="logInfo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PoliciesTableAdapter" GeneratorDataComponentClassName="PoliciesTableAdapter" Name="Policies" UserDataComponentName="PoliciesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Policies" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Policies] WHERE (([policyId] = @Original_policyId) AND ([policyName] = @Original_policyName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_policyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="policyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_policyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="policyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Policies] ([policyName]) VALUES (@policyName);
SELECT policyId, policyName FROM Policies WHERE (policyId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@policyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="policyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT policyId, policyName FROM dbo.Policies</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Policies] SET [policyName] = @policyName WHERE (([policyId] = @Original_policyId) AND ([policyName] = @Original_policyName));
SELECT policyId, policyName FROM Policies WHERE (policyId = @policyId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@policyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="policyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_policyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="policyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_policyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="policyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="policyId" ColumnName="policyId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@policyId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="policyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="policyId" DataSetColumn="policyId" />
              <Mapping SourceColumn="policyName" DataSetColumn="policyName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUsers" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetUsers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUsers" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Users] WHERE (([username] = @Original_username) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ([isActive] = @Original_isActive) AND ([userType] = @Original_userType) AND ([isLawBreaker] = @Original_isLawBreaker) AND ([isBanned] = @Original_isBanned))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLawBreaker" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLawBreaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isBanned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isBanned" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Users] ([username], [password], [isActive], [userType], [isLawBreaker], [isBanned]) VALUES (@username, @password, @isActive, @userType, @isLawBreaker, @isBanned);
SELECT username, password, isActive, userType, isLawBreaker, isBanned FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLawBreaker" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLawBreaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isBanned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isBanned" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     username, password, isActive, userType, isLawBreaker, isBanned
FROM         Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Users] SET [username] = @username, [password] = @password, [isActive] = @isActive, [userType] = @userType, [isLawBreaker] = @isLawBreaker, [isBanned] = @isBanned WHERE (([username] = @Original_username) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ([isActive] = @Original_isActive) AND ([userType] = @Original_userType) AND ([isLawBreaker] = @Original_isLawBreaker) AND ([isBanned] = @Original_isBanned));
SELECT username, password, isActive, userType, isLawBreaker, isBanned FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@userType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLawBreaker" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLawBreaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isBanned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isBanned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_userType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="userType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLawBreaker" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLawBreaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isBanned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isBanned" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="userType" DataSetColumn="userType" />
              <Mapping SourceColumn="isLawBreaker" DataSetColumn="isLawBreaker" />
              <Mapping SourceColumn="isBanned" DataSetColumn="isBanned" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByAdmin" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAdmin" GeneratorSourceName="FillByAdmin" GetMethodModifier="Public" GetMethodName="GetAdmin" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAdmin" UserSourceName="FillByAdmin">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT isActive, isBanned, isLawBreaker, password, userType, username FROM Users WHERE (userType = 'Admin')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMembers" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMembers" GeneratorSourceName="FillMembers" GetMethodModifier="Public" GetMethodName="GetMembers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMembers" UserSourceName="FillMembers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT isActive, isBanned, isLawBreaker, password, userType, username FROM Users WHERE (userType &lt;&gt; 'Guest')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="SetBanned" Modifier="Public" Name="SetBanned" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="SetBanned">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              isBanned = @isBanned
WHERE     (username = @Original_username); 
SELECT username, password, isActive, userType, isLawBreaker, isBanned FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="isBanned" ColumnName="isBanned" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isBanned" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isBanned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="setIsActive" Modifier="Public" Name="setIsActive" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="setIsActive">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              isActive = @isActive
WHERE     (username = @Original_username); 
SELECT username, password, isActive, userType, isLawBreaker, isBanned FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="isActive" ColumnName="isActive" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="SetLawBreaker" Modifier="Public" Name="SetLawBreaker" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="SetLawBreaker">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              isLawBreaker = @isLawBreaker
WHERE     (username = @Original_username); 
SELECT username, password, isActive, userType,isLawBreaker , isBanned  FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="isLawBreaker" ColumnName="isLawBreaker" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isLawBreaker" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isLawBreaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="SetUserType" Modifier="Public" Name="SetUserType" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="SetUserType">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              userType = @userType
WHERE     (username = @Original_username); 
SELECT username, password, isActive, userType,isLawBreaker ,isBanned FROM Users WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userType" ColumnName="userType" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@userType" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="userType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Users" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubForumsTableAdapter" GeneratorDataComponentClassName="SubForumsTableAdapter" Name="SubForums" UserDataComponentName="SubForumsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.SubForums" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SubForums] WHERE (([subForumTopic] = @Original_subForumTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SubForums] ([subForumTopic]) VALUES (@subForumTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT subForumTopic FROM dbo.SubForums</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SubForums] SET [subForumTopic] = @subForumTopic WHERE (([subForumTopic] = @Original_subForumTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="subForumTopic" DataSetColumn="subForumTopic" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModeratorInfoTableAdapter" GeneratorDataComponentClassName="ModeratorInfoTableAdapter" Name="ModeratorInfo" UserDataComponentName="ModeratorInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.ModeratorInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ModeratorInfo] WHERE (([username] = @Original_username) AND ([subForumTopic] = @Original_subForumTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ModeratorInfo] ([username], [subForumTopic], [since]) VALUES (@username, @subForumTopic, @since)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@since" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="since" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT username, subForumTopic, since FROM dbo.ModeratorInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ModeratorInfo] SET [username] = @username, [subForumTopic] = @subForumTopic, [since] = @since WHERE (([username] = @Original_username) AND ([subForumTopic] = @Original_subForumTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@since" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="since" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="subForumTopic" DataSetColumn="subForumTopic" />
              <Mapping SourceColumn="since" DataSetColumn="since" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteModeratorsBySubForum" Modifier="Public" Name="DeleteModeratorsBySubForum" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteModeratorsBySubForum">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[ModeratorInfo] 
WHERE ([subForumTopic] = @subForumTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="subForumTopic" ColumnName="subForumTopic" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.ModeratorInfo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.ModeratorInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillModeratorsBySubForumTopic" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetModeratorsBySubForumTopic" GeneratorSourceName="FillModeratorsBySubForumTopic" GetMethodModifier="Public" GetMethodName="GetModeratorsBySubForumTopic" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetModeratorsBySubForumTopic" UserSourceName="FillModeratorsBySubForumTopic">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     username, subForumTopic, since
FROM         ModeratorInfo
WHERE     (subForumTopic = @subForumTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="subForumTopic" ColumnName="subForumTopic" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.ModeratorInfo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThreadsTableAdapter" GeneratorDataComponentClassName="ThreadsTableAdapter" Name="Threads" UserDataComponentName="ThreadsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Threads" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Threads] WHERE (([thread_id] = @Original_thread_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_thread_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thread_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Threads] ([thread_subject], [thread_content], [publishedBy], [publishDate], [modifiedDate], [parentThread], [subForumTopic]) VALUES (@thread_subject, @thread_content, @publishedBy, @publishDate, @modifiedDate, @parentThread, @subForumTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@thread_subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thread_subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@thread_content" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="thread_content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@publishedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="publishedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@publishDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="publishDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@modifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="modifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parentThread" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parentThread" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT thread_id, thread_subject, thread_content, publishedBy, publishDate, modifiedDate, parentThread, subForumTopic FROM Threads</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Threads] SET [thread_subject] = @thread_subject, [thread_content] = @thread_content, [publishedBy] = @publishedBy, [publishDate] = @publishDate, [modifiedDate] = @modifiedDate, [parentThread] = @parentThread, [subForumTopic] = @subForumTopic WHERE (([thread_id] = @Original_thread_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@thread_subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thread_subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@thread_content" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="thread_content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@publishedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="publishedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@publishDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="publishDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@modifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="modifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parentThread" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parentThread" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_thread_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thread_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="thread_id" DataSetColumn="thread_id" />
              <Mapping SourceColumn="thread_subject" DataSetColumn="thread_subject" />
              <Mapping SourceColumn="thread_content" DataSetColumn="thread_content" />
              <Mapping SourceColumn="publishedBy" DataSetColumn="publishedBy" />
              <Mapping SourceColumn="publishDate" DataSetColumn="publishDate" />
              <Mapping SourceColumn="modifiedDate" DataSetColumn="modifiedDate" />
              <Mapping SourceColumn="parentThread" DataSetColumn="parentThread" />
              <Mapping SourceColumn="subForumTopic" DataSetColumn="subForumTopic" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Threads" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPostsByParentThread" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetPostsByParentThread" GeneratorSourceName="FillByPostsByParentThread" GetMethodModifier="Public" GetMethodName="GetPostsByParentThread" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPostsByParentThread" UserSourceName="FillByPostsByParentThread">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     thread_id, thread_subject, thread_content, publishedBy, publishDate, modifiedDate, parentThread, subForumTopic
FROM         Threads
WHERE     (parentThread = @parentThread)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="parentThread" ColumnName="parentThread" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@parentThread" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="parentThread" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Threads" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySubForumTopic" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySubForumTopic" GeneratorSourceName="FillBySubForumTopic" GetMethodModifier="Public" GetMethodName="GetDataBySubForumTopic" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySubForumTopic" UserSourceName="FillBySubForumTopic">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     thread_id, thread_subject, thread_content, publishedBy, publishDate, modifiedDate, parentThread, subForumTopic
FROM         Threads
WHERE     (parentThread IS NULL) AND (subForumTopic = @subForumTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="subForumTopic" ColumnName="subForumTopic" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Threads" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillThreadsByPublisher" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetThreadsByPublisher" GeneratorSourceName="FillThreadsByPublisher" GetMethodModifier="Public" GetMethodName="GetThreadsByPublisher" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetThreadsByPublisher" UserSourceName="FillThreadsByPublisher">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT thread_id, thread_subject, thread_content, publishedBy, publishDate, modifiedDate, parentThread, subForumTopic FROM Threads WHERE (publishedBy = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="publishedBy" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="publishedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Threads" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetLastMessagePublishedByAndTopic" GetMethodModifier="Public" GetMethodName="GetLastMessagePublishedByAndTopic" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLastMessagePublishedByAndTopic" UserSourceName="GetLastMessagePublishedByAndTopic">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP 1 thread_id, thread_subject, thread_content, publishedBy, publishDate, modifiedDate, parentThread, subForumTopic FROM Threads WHERE (publishedBy = @username) AND (subForumTopic = @topic)
ORDER BY publishDate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="publishedBy" DataSourceName="[C:\USERS\ALEX\DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="publishedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="topic" ColumnName="subForumTopic" DataSourceName="[C:\USERS\ALEX\DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@topic" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetMessagesCount" Modifier="Public" Name="GetMessagesCount" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetMessagesCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*)
FROM         Threads
WHERE     subForumTopic = @subForumTopic</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="subForumTopic" ColumnName="subForumTopic" DataSourceName="[C:\USERS\ALEX\DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@subForumTopic" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="subForumTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateThread" Modifier="Public" Name="UpdateThread" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateThread">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Threads
SET              thread_subject = @thread_subject, thread_content = @thread_content, modifiedDate = @modifiedDate
WHERE     (thread_id = @Original_thread_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="thread_subject" ColumnName="thread_subject" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@thread_subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="thread_subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="thread_content" ColumnName="thread_content" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@thread_content" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="thread_content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="modifiedDate" ColumnName="modifiedDate" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@modifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="modifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_thread_id" ColumnName="thread_id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ELIOR\MY DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\GEEBA\WCFGEEBASERVER\APP_DATA\GEEBADB.MDF].dbo.Threads" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_thread_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="thread_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PropertiesTableAdapter" GeneratorDataComponentClassName="PropertiesTableAdapter" Name="Properties" UserDataComponentName="PropertiesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Properties" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Properties] WHERE (([properyId] = @Original_properyId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_properyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="properyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Properties] ([property], [val]) VALUES (@property, @val)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@property" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="property" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@val" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT properyId, property, val FROM dbo.Properties</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Properties] SET [property] = @property, [val] = @val WHERE (([properyId] = @Original_properyId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@property" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="property" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@val" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_properyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="properyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="properyId" DataSetColumn="properyId" />
              <Mapping SourceColumn="property" DataSetColumn="property" />
              <Mapping SourceColumn="val" DataSetColumn="val" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RulesTableAdapter" GeneratorDataComponentClassName="RulesTableAdapter" Name="Rules" UserDataComponentName="RulesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GeebaDBConnectionString (Settings)" DbObjectName="dbo.Rules" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Rules] WHERE (([ruleId] = @Original_ruleId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ruleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Rules] ([policyId], [ruleDescription], [ruleP1], [ruleP2], [ruleP3]) VALUES (@policyId, @ruleDescription, @ruleP1, @ruleP2, @ruleP3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@policyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="policyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruleDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruleDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ruleId, policyId, ruleDescription, ruleP1, ruleP2, ruleP3 FROM dbo.Rules</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Rules] SET [policyId] = @policyId, [ruleDescription] = @ruleDescription, [ruleP1] = @ruleP1, [ruleP2] = @ruleP2, [ruleP3] = @ruleP3 WHERE (([ruleId] = @Original_ruleId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@policyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="policyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruleDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruleDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ruleP3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleP3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ruleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ruleId" DataSetColumn="ruleId" />
              <Mapping SourceColumn="policyId" DataSetColumn="policyId" />
              <Mapping SourceColumn="ruleDescription" DataSetColumn="ruleDescription" />
              <Mapping SourceColumn="ruleP1" DataSetColumn="ruleP1" />
              <Mapping SourceColumn="ruleP2" DataSetColumn="ruleP2" />
              <Mapping SourceColumn="ruleP3" DataSetColumn="ruleP3" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GeebaDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="GeebaDS" msprop:Generator_UserDSName="GeebaDS">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="LoggedMembers" msprop:Generator_TableClassName="LoggedMembersDataTable" msprop:Generator_TableVarName="tableLoggedMembers" msprop:Generator_TablePropName="LoggedMembers" msprop:Generator_RowDeletingName="LoggedMembersRowDeleting" msprop:Generator_UserTableName="LoggedMembers" msprop:Generator_RowChangingName="LoggedMembersRowChanging" msprop:Generator_RowEvHandlerName="LoggedMembersRowChangeEventHandler" msprop:Generator_RowDeletedName="LoggedMembersRowDeleted" msprop:Generator_RowEvArgName="LoggedMembersRowChangeEvent" msprop:Generator_RowChangedName="LoggedMembersRowChanged" msprop:Generator_RowClassName="LoggedMembersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="loginId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnloginId" msprop:Generator_ColumnPropNameInRow="loginId" msprop:Generator_ColumnPropNameInTable="loginIdColumn" msprop:Generator_UserColumnName="loginId" type="xs:int" />
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loginDate" msprop:Generator_ColumnVarNameInTable="columnloginDate" msprop:Generator_ColumnPropNameInRow="loginDate" msprop:Generator_ColumnPropNameInTable="loginDateColumn" msprop:Generator_UserColumnName="loginDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Logging" msprop:Generator_TableClassName="LoggingDataTable" msprop:Generator_TableVarName="tableLogging" msprop:Generator_TablePropName="Logging" msprop:Generator_RowDeletingName="LoggingRowDeleting" msprop:Generator_UserTableName="Logging" msprop:Generator_RowChangingName="LoggingRowChanging" msprop:Generator_RowEvHandlerName="LoggingRowChangeEventHandler" msprop:Generator_RowDeletedName="LoggingRowDeleted" msprop:Generator_RowEvArgName="LoggingRowChangeEvent" msprop:Generator_RowChangedName="LoggingRowChanged" msprop:Generator_RowClassName="LoggingRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="logId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnlogId" msprop:Generator_ColumnPropNameInRow="logId" msprop:Generator_ColumnPropNameInTable="logIdColumn" msprop:Generator_UserColumnName="logId" type="xs:int" />
              <xs:element name="logDate" msprop:Generator_ColumnVarNameInTable="columnlogDate" msprop:Generator_ColumnPropNameInRow="logDate" msprop:Generator_ColumnPropNameInTable="logDateColumn" msprop:Generator_UserColumnName="logDate" type="xs:dateTime" />
              <xs:element name="logInfo" msprop:Generator_ColumnVarNameInTable="columnlogInfo" msprop:Generator_ColumnPropNameInRow="logInfo" msprop:Generator_ColumnPropNameInTable="logInfoColumn" msprop:Generator_UserColumnName="logInfo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Policies" msprop:Generator_TableClassName="PoliciesDataTable" msprop:Generator_TableVarName="tablePolicies" msprop:Generator_TablePropName="Policies" msprop:Generator_RowDeletingName="PoliciesRowDeleting" msprop:Generator_UserTableName="Policies" msprop:Generator_RowChangingName="PoliciesRowChanging" msprop:Generator_RowEvHandlerName="PoliciesRowChangeEventHandler" msprop:Generator_RowDeletedName="PoliciesRowDeleted" msprop:Generator_RowEvArgName="PoliciesRowChangeEvent" msprop:Generator_RowChangedName="PoliciesRowChanged" msprop:Generator_RowClassName="PoliciesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="policyId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnpolicyId" msprop:Generator_ColumnPropNameInRow="policyId" msprop:Generator_ColumnPropNameInTable="policyIdColumn" msprop:Generator_UserColumnName="policyId" type="xs:int" />
              <xs:element name="policyName" msprop:Generator_ColumnVarNameInTable="columnpolicyName" msprop:Generator_ColumnPropNameInRow="policyName" msprop:Generator_ColumnPropNameInTable="policyNameColumn" msprop:Generator_UserColumnName="policyName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" />
              <xs:element name="userType" msprop:Generator_ColumnVarNameInTable="columnuserType" msprop:Generator_ColumnPropNameInRow="userType" msprop:Generator_ColumnPropNameInTable="userTypeColumn" msprop:Generator_UserColumnName="userType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isLawBreaker" msprop:Generator_ColumnVarNameInTable="columnisLawBreaker" msprop:Generator_ColumnPropNameInRow="isLawBreaker" msprop:Generator_ColumnPropNameInTable="isLawBreakerColumn" msprop:Generator_UserColumnName="isLawBreaker" type="xs:boolean" default="false" />
              <xs:element name="isBanned" msprop:Generator_ColumnVarNameInTable="columnisBanned" msprop:Generator_ColumnPropNameInRow="isBanned" msprop:Generator_ColumnPropNameInTable="isBannedColumn" msprop:Generator_UserColumnName="isBanned" type="xs:boolean" default="false" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SubForums" msprop:Generator_TableClassName="SubForumsDataTable" msprop:Generator_TableVarName="tableSubForums" msprop:Generator_TablePropName="SubForums" msprop:Generator_RowDeletingName="SubForumsRowDeleting" msprop:Generator_UserTableName="SubForums" msprop:Generator_RowChangingName="SubForumsRowChanging" msprop:Generator_RowEvHandlerName="SubForumsRowChangeEventHandler" msprop:Generator_RowDeletedName="SubForumsRowDeleted" msprop:Generator_RowEvArgName="SubForumsRowChangeEvent" msprop:Generator_RowChangedName="SubForumsRowChanged" msprop:Generator_RowClassName="SubForumsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="subForumTopic" msprop:Generator_ColumnVarNameInTable="columnsubForumTopic" msprop:Generator_ColumnPropNameInRow="subForumTopic" msprop:Generator_ColumnPropNameInTable="subForumTopicColumn" msprop:Generator_UserColumnName="subForumTopic">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ModeratorInfo" msprop:Generator_TableClassName="ModeratorInfoDataTable" msprop:Generator_TableVarName="tableModeratorInfo" msprop:Generator_TablePropName="ModeratorInfo" msprop:Generator_RowDeletingName="ModeratorInfoRowDeleting" msprop:Generator_UserTableName="ModeratorInfo" msprop:Generator_RowChangingName="ModeratorInfoRowChanging" msprop:Generator_RowEvHandlerName="ModeratorInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="ModeratorInfoRowDeleted" msprop:Generator_RowEvArgName="ModeratorInfoRowChangeEvent" msprop:Generator_RowChangedName="ModeratorInfoRowChanged" msprop:Generator_RowClassName="ModeratorInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="subForumTopic" msprop:Generator_ColumnVarNameInTable="columnsubForumTopic" msprop:Generator_ColumnPropNameInRow="subForumTopic" msprop:Generator_ColumnPropNameInTable="subForumTopicColumn" msprop:Generator_UserColumnName="subForumTopic">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="since" msprop:Generator_ColumnVarNameInTable="columnsince" msprop:Generator_ColumnPropNameInRow="since" msprop:Generator_ColumnPropNameInTable="sinceColumn" msprop:Generator_UserColumnName="since" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Threads" msprop:Generator_TableClassName="ThreadsDataTable" msprop:Generator_TableVarName="tableThreads" msprop:Generator_TablePropName="Threads" msprop:Generator_RowDeletingName="ThreadsRowDeleting" msprop:Generator_UserTableName="Threads" msprop:Generator_RowChangingName="ThreadsRowChanging" msprop:Generator_RowEvHandlerName="ThreadsRowChangeEventHandler" msprop:Generator_RowDeletedName="ThreadsRowDeleted" msprop:Generator_RowEvArgName="ThreadsRowChangeEvent" msprop:Generator_RowChangedName="ThreadsRowChanged" msprop:Generator_RowClassName="ThreadsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="thread_id" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnthread_id" msprop:Generator_ColumnPropNameInRow="thread_id" msprop:Generator_ColumnPropNameInTable="thread_idColumn" msprop:Generator_UserColumnName="thread_id" type="xs:int" />
              <xs:element name="thread_subject" msprop:Generator_ColumnVarNameInTable="columnthread_subject" msprop:Generator_ColumnPropNameInRow="thread_subject" msprop:Generator_ColumnPropNameInTable="thread_subjectColumn" msprop:Generator_UserColumnName="thread_subject">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thread_content" msprop:Generator_ColumnVarNameInTable="columnthread_content" msprop:Generator_ColumnPropNameInRow="thread_content" msprop:Generator_ColumnPropNameInTable="thread_contentColumn" msprop:Generator_UserColumnName="thread_content">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="publishedBy" msprop:Generator_ColumnVarNameInTable="columnpublishedBy" msprop:Generator_ColumnPropNameInRow="publishedBy" msprop:Generator_ColumnPropNameInTable="publishedByColumn" msprop:Generator_UserColumnName="publishedBy">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="publishDate" msprop:Generator_ColumnVarNameInTable="columnpublishDate" msprop:Generator_ColumnPropNameInRow="publishDate" msprop:Generator_ColumnPropNameInTable="publishDateColumn" msprop:Generator_UserColumnName="publishDate" type="xs:dateTime" />
              <xs:element name="modifiedDate" msprop:Generator_ColumnVarNameInTable="columnmodifiedDate" msprop:Generator_ColumnPropNameInRow="modifiedDate" msprop:Generator_ColumnPropNameInTable="modifiedDateColumn" msprop:Generator_UserColumnName="modifiedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="parentThread" msprop:Generator_ColumnVarNameInTable="columnparentThread" msprop:Generator_ColumnPropNameInRow="parentThread" msprop:Generator_ColumnPropNameInTable="parentThreadColumn" msprop:Generator_UserColumnName="parentThread" type="xs:int" minOccurs="0" />
              <xs:element name="subForumTopic" msprop:Generator_ColumnVarNameInTable="columnsubForumTopic" msprop:Generator_ColumnPropNameInRow="subForumTopic" msprop:Generator_ColumnPropNameInTable="subForumTopicColumn" msprop:Generator_UserColumnName="subForumTopic">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Properties" msprop:Generator_TableClassName="PropertiesDataTable" msprop:Generator_TableVarName="tableProperties" msprop:Generator_TablePropName="Properties" msprop:Generator_RowDeletingName="PropertiesRowDeleting" msprop:Generator_UserTableName="Properties" msprop:Generator_RowChangingName="PropertiesRowChanging" msprop:Generator_RowEvHandlerName="PropertiesRowChangeEventHandler" msprop:Generator_RowDeletedName="PropertiesRowDeleted" msprop:Generator_RowEvArgName="PropertiesRowChangeEvent" msprop:Generator_RowChangedName="PropertiesRowChanged" msprop:Generator_RowClassName="PropertiesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="properyId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnproperyId" msprop:Generator_ColumnPropNameInRow="properyId" msprop:Generator_ColumnPropNameInTable="properyIdColumn" msprop:Generator_UserColumnName="properyId" type="xs:int" />
              <xs:element name="property" msprop:Generator_ColumnVarNameInTable="columnproperty" msprop:Generator_ColumnPropNameInRow="property" msprop:Generator_ColumnPropNameInTable="propertyColumn" msprop:Generator_UserColumnName="property" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="val" msprop:Generator_ColumnVarNameInTable="columnval" msprop:Generator_ColumnPropNameInRow="val" msprop:Generator_ColumnPropNameInTable="valColumn" msprop:Generator_UserColumnName="val" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Rules" msprop:Generator_TableClassName="RulesDataTable" msprop:Generator_TableVarName="tableRules" msprop:Generator_TablePropName="Rules" msprop:Generator_RowDeletingName="RulesRowDeleting" msprop:Generator_UserTableName="Rules" msprop:Generator_RowChangingName="RulesRowChanging" msprop:Generator_RowEvHandlerName="RulesRowChangeEventHandler" msprop:Generator_RowDeletedName="RulesRowDeleted" msprop:Generator_RowEvArgName="RulesRowChangeEvent" msprop:Generator_RowChangedName="RulesRowChanged" msprop:Generator_RowClassName="RulesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ruleId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnruleId" msprop:Generator_ColumnPropNameInRow="ruleId" msprop:Generator_ColumnPropNameInTable="ruleIdColumn" msprop:Generator_UserColumnName="ruleId" type="xs:int" />
              <xs:element name="policyId" msprop:Generator_ColumnVarNameInTable="columnpolicyId" msprop:Generator_ColumnPropNameInRow="policyId" msprop:Generator_ColumnPropNameInTable="policyIdColumn" msprop:Generator_UserColumnName="policyId" type="xs:int" />
              <xs:element name="ruleDescription" msprop:Generator_ColumnVarNameInTable="columnruleDescription" msprop:Generator_ColumnPropNameInRow="ruleDescription" msprop:Generator_ColumnPropNameInTable="ruleDescriptionColumn" msprop:Generator_UserColumnName="ruleDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ruleP1" msprop:Generator_ColumnVarNameInTable="columnruleP1" msprop:Generator_ColumnPropNameInRow="ruleP1" msprop:Generator_ColumnPropNameInTable="ruleP1Column" msprop:Generator_UserColumnName="ruleP1" type="xs:int" minOccurs="0" />
              <xs:element name="ruleP2" msprop:Generator_ColumnVarNameInTable="columnruleP2" msprop:Generator_ColumnPropNameInRow="ruleP2" msprop:Generator_ColumnPropNameInTable="ruleP2Column" msprop:Generator_UserColumnName="ruleP2" type="xs:int" minOccurs="0" />
              <xs:element name="ruleP3" msprop:Generator_ColumnVarNameInTable="columnruleP3" msprop:Generator_ColumnPropNameInRow="ruleP3" msprop:Generator_ColumnPropNameInTable="ruleP3Column" msprop:Generator_UserColumnName="ruleP3" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LoggedMembers" />
      <xs:field xpath="mstns:loginId" />
    </xs:unique>
    <xs:unique name="Logging_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Logging" />
      <xs:field xpath="mstns:logId" />
    </xs:unique>
    <xs:unique name="Policies_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Policies" />
      <xs:field xpath="mstns:policyId" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:username" />
    </xs:unique>
    <xs:unique name="SubForums_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SubForums" />
      <xs:field xpath="mstns:subForumTopic" />
    </xs:unique>
    <xs:unique name="ModeratorInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ModeratorInfo" />
      <xs:field xpath="mstns:username" />
      <xs:field xpath="mstns:subForumTopic" />
    </xs:unique>
    <xs:unique name="Threads_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Threads" />
      <xs:field xpath="mstns:thread_id" />
    </xs:unique>
    <xs:unique name="Properties_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Properties" />
      <xs:field xpath="mstns:properyId" />
    </xs:unique>
    <xs:unique name="Rules_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Rules" />
      <xs:field xpath="mstns:ruleId" />
    </xs:unique>
  </xs:element>
</xs:schema>